This assignment is for ETC5521 Assignment 1 by Team Lorikeet comprising of Aryan Jain and Emily Sheehan.

Introduction and motivation

Measles is a highly infectious disease caused by the Measles virus. It can lead to pneumonia, infections of the middle ear, swelling of the brain and death.

A vaccine exists to prevent the onset of measles as there is no treatment. The vaccine involves the injection of attenuated measles antigens that stimulate the production of antibodies and memory cells, providing long-term protection against the virus. When administered properly, the vaccine is 90.5% effective within 72 hours of exposure (Barrabeig et al., 2011).

Unfortunately there is a growing number of individuals refusing vaccination, particularly in the US (Phadke et al., 2016). In Texas, the number of unvaccinated children attaining exemptions to attend school has increased by 28 times since 2003 (Sinclair et al., 2019). This has led to several outbreaks of vaccine preventable diseases, such as Measles. If this trend continues, there could be calamitous consequences.

This paper hopes to understand the reasons for vaccine refusal and determine whether there is a relationship between socio-economic status and vaccination rate. To analyse the relationship a dataset has been scraped from WSJ github repository. Although every precaution has been taken to ensure accurate figures have been calculated, some of the MMR rates, overall vaccination rates and school types were missing from the original dataset. The missing data was identified using naniar, and removed to reduce the impact on the figures calculated.

PERHAPS EXPLAIN DATA SOURCES IN MORE DETAIL

Data description

The data comprises of vaccination rates for 46,412 schools in 32 U.S states and was retrieved from The Wall Street Journal. The variables include; the school academic year, the school’s state, city, county, district, name, type, enrollment, MMR (measles, mumps and rubella) vaccination rate, overall vaccination rate, latitude, longitude and the percentage of students exempted from vaccinations due to personal, religious or medical reasons.

The data was collected in the 2017-18 school year for 11 states and 2018-19 school year for the remaining 21 states. The state health departments provided the vaccination data and the National Center for Education Statistic’s provided the school location, which was matched against the school name. In the case that there was no match, the school’s location was found with Google Maps API.

The individual state dataset was scraped from WSJ github repository and combined with the existing measles dataset with left_join to extract the longitude and latitude variables from it. Various functions from the rvest package were used to scrape the data including read_html and html_table.

Primary Question: Does Measles vaccination rate improve with better socio-economic conditions?

Secondary Questions:

Analysis and findings

Is the MMR vaccination rate higher in private schools?

The data was filtered to remove missing school type, overall vaccination rate and MMR rate. It was grouped by type and the average MMR vaccination rate and overall vaccination rate was calculated using the mean function. The tibble generated was named school_type_average. Then, the average MMR rates from the school_type_average tibble were plotted. The rates were annotated accordingly to draw attention to the difference between the MMR vaccination rate for each school type.

Interestingly enough, the overall vaccination rate and the MMR vaccination rate was the highest in public schools when compared to the rates in Kindergartens and private schools. This is consistent with findings from a study conducted by Shaw (2014) where it was found that private schools have higher rates of exemptions for immunisations than public schools.

How does the MMR vaccination rate compare to the school’s overall vaccination rate?

The school_type_average was tabulated to compare the overall vaccination rate and MMR vaccination rate. Then, both rates were plotted according to school type.

Comparison of both Average Vaccination Rates according to School Type
Type Average MMR Vaccination Rate Average Overall Vaccination Rate
Kindergarten 94.2% 88.0%
Private 93.2% 91.4%
Public 95.9% 94.5%

When comparing the vaccination

Aryan section

NOTE - I have filled with the colours to match, but i dont know if that looks any good so we can change!

Question 1

  • grouped by states, found mean mmr and overall
  • used map_data to plot the map, creates a tibble of the geogrpahical info of states (lat,long,)
  • then merged with measles_states, filtered out missing values <0, then plotted with geom polygon
  • then sketched a bar chart

Question 2

  • external dataset from taxfoundation (add link), merged that data with the measles density data
  • tabulated and then plotted in geomcol (income per capita against the vaccination rate for overall then mmr), then gg arrange to plot side by side
The PCI of the States with the Highest MMR Vaccination Rate
State MMR PCI
Illinois 97.39% $56,839
Pennsylvania 96.89% $56,225
Utah 95.04% $46,320
Colorado 94.09% $58,456
New York 93.45% $68,668
The PCI of the States with the Lowest MMR Vaccination Rate
State MMR PCI
Massachusetts 57.68% $71,683
Connecticut 71.44% $76,456
Arizona 74.56% $44,329
Montana 76.20% $47,538
Washington 79.45% $62,026

The PCI of the States with the Highest Overall Vaccination Rate
State Overall PCI
North Carolina 96.779% $46,117
Tennessee 95.023% $46,900
Florida 92.487% $50,070
Michigan 91.809% $48,423
Oregon 90.265% $50,843
The PCI of the States with the Lowest Overall Vaccination Rate
State Overall PCI
Washington 75.238% $62,026
Oklahoma 76.858% $46,233
Idaho 81.036% $43,901
Iowa 81.275% $50,124
Ohio 82.113% $48,739

References

https://github.com/TaxFoundation/facts-and-figures

Emily’s references (I will fix up in APA)

measles definition - https://www.health.gov.au/health-topics/measles#what-is-measles

how vaccine works - https://www.health.qld.gov.au/news-events/news/what-is-measles-why-vaccinate#:~:text=The%20measles%20vaccine%20contains%20a,is%20better%20prepared%20to%20respond.

why people arent vaccinating - Cockcroft, A., Usman, M. U., Nyamucherera, O. F., Emori, H., Duke, B., Umar, N. A., & Andersson, N. (2014). Why children are not vaccinated against measles: a cross-sectional study in two Nigerian States. Archives of Public Health = Archives Belges de Sante Publique, 72(1), 48.

effectiveness stat - Barrabeig, I., Rovira, A., Rius, C., Muñoz, P., Soldevila, N., Batalla, J., & Domínguez, A. (2011). Effectiveness of measles vaccination for control of exposed children. The Pediatric Infectious Disease Journal, 30(1), 78–80.

growing number of refusal - Phadke, V. K., Bednarczyk, R. A., Salmon, D. A., & Omer, S. B. (2016). Association Between Vaccine Refusal and Vaccine-Preventable Diseases in the United States: A Review of Measles and Pertussis. JAMA: The Journal of the American Medical Association, 315(11), 1149–1158.

28 times - Sinclair, D. R., Grefenstette, J. J., Krauland, M. G., Galloway, D. D., Frankeny, R. J., Travis, C., Burke, D. S., & Roberts, M. S. (2019). Forecasted Size of Measles Outbreaks Associated With Vaccination Exemptions for Schoolchildren. JAMA Network Open, 2(8), e199768.

public higher than private - Shaw, J., Tserenpuntsag, B., McNutt, L.-A., & Halsey, N. (2014). United States private schools have higher rates of exemptions to school immunization requirements than public schools. The Journal of Pediatrics, 165(1), 129–133.